Model Table BUSINESS ACTIVITY DIM

This model dimension represents business activities and is based on the IFS Cloud fact FACT_BUSINESS_ACTIVITY. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute	Description (where applicable)
Activity Type	The Activity Type shows whether the activity is a Meeting, Task, Call, Chat or E-Mail.
Activity Type Description	The Activity Type shows whether the activity is a Meeting, Task, Call, Chat or E-Mail.
Business Activity	The ID of the business activity.
Business Activity Connection ID	The connection (customer, supplier, lead etc.) which is the business activity is created for.
Business Activity Connection ID Activity	The connection (customer, supplier, lead etc.) which is the business activity is created for.
Business Activity Connection Type	The connection type (customer, supplier, lead etc.) related to the business activity.
Business Activity Connection Type Description	The connection type (customer, supplier, lead etc.) related to the business activity.
Business Activity Description	The description of the business activity.
Business Activity Number	The ID of the business activity.
Main Representative	Not Needed

USED BY MODEL(S)

Model Name

Crm

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
BUSINESS ACTIVITY DIM	DIM_BUSINESS_ACTIVITY_TM	DIM_BUSINESS_ACTIVITY_BI	DIM_BUSINESS_ACTIVITY	On Line